const mysql = require("mysql");

var con = mysql.createConnection({
    host: "192.168.16.144",
    port: 3306,
    user: "root",
    password: "ddd",
    database:"dataexercise"
})

var obj = {};

obj.query = async function(sqlStr, arr){
    return await new Promise((resolve,reject)=>{
        con.query(sqlStr, arr, (err, result)=>{
            if(err){
                reject(err);
            }
            else{
                resolve(result);
            }
        })
    })
    
}

module.exports = obj;